SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_AddPortalAlias
	@PortalID 			int,
	@HTTPAlias 			nvarchar(200),
	@CreatedByUserID	int

AS

INSERT INTO dbo.DnnProduct_PortalAlias (
	PortalID, 
	HTTPAlias,
	CreatedByUserID,
	CreatedOnDate,
	LastModifiedByUserID,
	LastModifiedOnDate
)
VALUES (
	@PortalID, 
	@HTTPAlias,
	@CreatedByUserID,
	getdate(),
	@CreatedByUserID,
	getdate()
 )

SELECT SCOPE_IDENTITY()
GO
